Text copied to clipboard!
Title
Text copied to clipboard!Query Optimization for PHP Monolithic LMS
Description
Text copied to clipboard!
We are looking for an experienced professional in query optimization for a monolithic Learning Management System (LMS) developed in PHP. The ideal candidate will have deep knowledge of relational databases, especially MySQL, and will be able to identify performance bottlenecks, propose improvements, and implement effective solutions to optimize query response times.
The LMS system is used by thousands of users simultaneously, requiring high levels of performance and stability. The professional will be responsible for reviewing existing SQL queries, proposing index restructuring, table normalization or denormalization, and collaborating with the development team to ensure best practices in data access are followed.
Additionally, the role requires performing load testing, performance monitoring, and log analysis to identify critical points. Knowledge of PHP application profiling and tools such as Xdebug, New Relic, or similar will be considered a plus.
This role is essential to ensure the scalability and efficiency of the system, directly contributing to the end-user experience and the long-term sustainability of the platform.
Responsibilities
Text copied to clipboard!- Analyze and optimize SQL queries in monolithic PHP systems
- Identify performance bottlenecks in databases
- Restructure indexes and tables for better performance
- Collaborate with developers to implement data access best practices
- Conduct load and stress testing
- Monitor performance metrics and logs
- Document changes and improvements made
- Participate in technical meetings for solution alignment
- Propose continuous improvements in data architecture
- Ensure scalability of the LMS system
Requirements
Text copied to clipboard!- Proven experience with PHP and MySQL
- Advanced knowledge in SQL query optimization
- Familiarity with monolithic systems
- Experience with profiling tools like Xdebug or New Relic
- Analytical skills to identify and solve performance issues
- Knowledge in relational data modeling
- Good communication and teamwork skills
- Desirable experience with LMS systems
- Knowledge of version control with Git
- Degree in Computer Science or related fields
Potential interview questions
Text copied to clipboard!- Do you have experience with monolithic LMS systems?
- What tools do you use for performance analysis in PHP?
- How do you approach optimizing a slow query?
- Have you worked with PHP application profiling?
- How do you ensure the scalability of a monolithic system?
- Do you have experience with load and stress testing?
- Have you worked on index restructuring in databases?
- How do you document your optimizations?
- Have you used tools like New Relic or similar?
- What was the biggest performance challenge you faced?
